﻿
USE [master]
GO
/****** Object:  Database [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF]    Script Date: 09/16/2010 22:11:14 ******/
CREATE DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] ON  PRIMARY 
( NAME = N'WebNote', FILENAME = N'D:\1 Hisham\amal\WebShell\Pages\App_Data\WebNote.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'WebNote_log', FILENAME = N'D:\1 Hisham\amal\WebShell\Pages\App_Data\WebNote_log.ldf' , SIZE = 504KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET ANSI_NULLS OFF
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET ANSI_PADDING OFF
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET ARITHABORT OFF
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET AUTO_CLOSE ON
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET AUTO_SHRINK ON
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET  DISABLE_BROKER
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET  READ_WRITE
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET RECOVERY SIMPLE
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET  MULTI_USER
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF] SET DB_CHAINING OFF
GO
USE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF]
GO
/****** Object:  ForeignKey [FK_UserRole_Role]    Script Date: 09/16/2010 22:11:17 ******/
ALTER TABLE [dbo].[UserRole] DROP CONSTRAINT [FK_UserRole_Role]
GO
/****** Object:  ForeignKey [FK_UserRole_User]    Script Date: 09/16/2010 22:11:17 ******/
ALTER TABLE [dbo].[UserRole] DROP CONSTRAINT [FK_UserRole_User]
GO
/****** Object:  ForeignKey [FK_Note_User]    Script Date: 09/16/2010 22:11:17 ******/
ALTER TABLE [dbo].[Note] DROP CONSTRAINT [FK_Note_User]
GO
/****** Object:  ForeignKey [FK_KeyValue_Keyword]    Script Date: 09/16/2010 22:11:17 ******/
ALTER TABLE [dbo].[KeyValue] DROP CONSTRAINT [FK_KeyValue_Keyword]
GO
/****** Object:  ForeignKey [FK_KeyValue_Language]    Script Date: 09/16/2010 22:11:17 ******/
ALTER TABLE [dbo].[KeyValue] DROP CONSTRAINT [FK_KeyValue_Language]
GO
/****** Object:  Table [dbo].[KeyValue]    Script Date: 09/16/2010 22:11:17 ******/
ALTER TABLE [dbo].[KeyValue] DROP CONSTRAINT [FK_KeyValue_Keyword]
GO
ALTER TABLE [dbo].[KeyValue] DROP CONSTRAINT [FK_KeyValue_Language]
GO
DROP TABLE [dbo].[KeyValue]
GO
/****** Object:  Table [dbo].[Note]    Script Date: 09/16/2010 22:11:17 ******/
ALTER TABLE [dbo].[Note] DROP CONSTRAINT [FK_Note_User]
GO
ALTER TABLE [dbo].[Note] DROP CONSTRAINT [DF_Note_isPublic]
GO
DROP TABLE [dbo].[Note]
GO
/****** Object:  Table [dbo].[UserRole]    Script Date: 09/16/2010 22:11:17 ******/
ALTER TABLE [dbo].[UserRole] DROP CONSTRAINT [FK_UserRole_Role]
GO
ALTER TABLE [dbo].[UserRole] DROP CONSTRAINT [FK_UserRole_User]
GO
DROP TABLE [dbo].[UserRole]
GO
/****** Object:  Table [dbo].[Role]    Script Date: 09/16/2010 22:11:17 ******/
DROP TABLE [dbo].[Role]
GO
/****** Object:  Table [dbo].[User]    Script Date: 09/16/2010 22:11:17 ******/
DROP TABLE [dbo].[User]
GO
/****** Object:  Table [dbo].[Keyword]    Script Date: 09/16/2010 22:11:17 ******/
DROP TABLE [dbo].[Keyword]
GO
/****** Object:  Table [dbo].[Language]    Script Date: 09/16/2010 22:11:17 ******/
DROP TABLE [dbo].[Language]
GO
USE [master]
GO
/****** Object:  Login [##MS_PolicyEventProcessingLogin##]    Script Date: 09/16/2010 22:11:15 ******/
DROP LOGIN [##MS_PolicyEventProcessingLogin##]
GO
/****** Object:  Login [##MS_PolicyTsqlExecutionLogin##]    Script Date: 09/16/2010 22:11:15 ******/
DROP LOGIN [##MS_PolicyTsqlExecutionLogin##]
GO
/****** Object:  Login [BUILTIN\Administrators]    Script Date: 09/16/2010 22:11:15 ******/
DROP LOGIN [BUILTIN\Administrators]
GO
/****** Object:  Login [BUILTIN\Users]    Script Date: 09/16/2010 22:11:14 ******/
DROP LOGIN [BUILTIN\Users]
GO
/****** Object:  Login [EMEA\czvl4p]    Script Date: 09/16/2010 22:11:14 ******/
DROP LOGIN [EMEA\czvl4p]
GO
/****** Object:  Login [NT AUTHORITY\SYSTEM]    Script Date: 09/16/2010 22:11:14 ******/
DROP LOGIN [NT AUTHORITY\SYSTEM]
GO
/****** Object:  Login [W2CZVL4P04\SQLServer2005MSSQLUser$W2CZVL4P04$SQLEXPRESS]    Script Date: 09/16/2010 22:11:14 ******/
DROP LOGIN [W2CZVL4P04\SQLServer2005MSSQLUser$W2CZVL4P04$SQLEXPRESS]
GO
/****** Object:  Login [wnuser]    Script Date: 09/16/2010 22:11:14 ******/
DROP LOGIN [wnuser]
GO
/****** Object:  Login [wnuser]    Script Date: 09/16/2010 22:11:14 ******/
/* For security reasons the login is created disabled and with a random password. */
CREATE LOGIN [wnuser] WITH PASSWORD=N'CµI·IÍã>¬ÌÃg¬WA,_Ö0^çÄ', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
GO
ALTER LOGIN [wnuser] DISABLE
GO
/****** Object:  Login [W2CZVL4P04\SQLServer2005MSSQLUser$W2CZVL4P04$SQLEXPRESS]    Script Date: 09/16/2010 22:11:14 ******/
CREATE LOGIN [W2CZVL4P04\SQLServer2005MSSQLUser$W2CZVL4P04$SQLEXPRESS] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]
GO
/****** Object:  Login [NT AUTHORITY\SYSTEM]    Script Date: 09/16/2010 22:11:14 ******/
CREATE LOGIN [NT AUTHORITY\SYSTEM] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]
GO
/****** Object:  Login [EMEA\czvl4p]    Script Date: 09/16/2010 22:11:14 ******/
CREATE LOGIN [EMEA\czvl4p] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]
GO
/****** Object:  Login [BUILTIN\Users]    Script Date: 09/16/2010 22:11:14 ******/
CREATE LOGIN [BUILTIN\Users] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]
GO
/****** Object:  Login [BUILTIN\Administrators]    Script Date: 09/16/2010 22:11:15 ******/
CREATE LOGIN [BUILTIN\Administrators] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]
GO
/****** Object:  Login [##MS_PolicyTsqlExecutionLogin##]    Script Date: 09/16/2010 22:11:15 ******/
/* For security reasons the login is created disabled and with a random password. */
CREATE LOGIN [##MS_PolicyTsqlExecutionLogin##] WITH PASSWORD=N'
\geÅ$Oúâù}¯Ë¸g±ÞãÅ¼m´¦	ùÝä', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
GO
ALTER LOGIN [##MS_PolicyTsqlExecutionLogin##] DISABLE
GO
/****** Object:  Login [##MS_PolicyEventProcessingLogin##]    Script Date: 09/16/2010 22:11:15 ******/
/* For security reasons the login is created disabled and with a random password. */
CREATE LOGIN [##MS_PolicyEventProcessingLogin##] WITH PASSWORD=N'=©äYÍoa§s''ÅcÄïøxY+Ãu', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
GO
ALTER LOGIN [##MS_PolicyEventProcessingLogin##] DISABLE
GO
USE [D:\1 HISHAM\AMAL\WEBSHELL\PAGES\APP_DATA\WEBNOTE.MDF]
GO
/****** Object:  Table [dbo].[Language]    Script Date: 09/16/2010 22:11:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object:  Table [dbo].[Keyword]    Script Date: 09/16/2010 22:11:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object:  Table [dbo].[User]    Script Date: 09/16/2010 22:11:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET IDENTITY_INSERT [dbo].[User] ON
GO
INSERT [dbo].[User] ([Id], [Name], [Password], [Email]) VALUES (4, N'hisham.elbreky', N'T0d1E/mgoI2PicbWC1iU2w==', N'hisham.elbreky@hotmail.com')
GO
INSERT [dbo].[User] ([Id], [Name], [Password], [Email]) VALUES (5, N'hisham.elbreky', N'T0d1E/mgoI2PicbWC1iU2w==', N'hisham.elbreky@gmail.com')
GO
INSERT [dbo].[User] ([Id], [Name], [Password], [Email]) VALUES (7, N'someone', N'MMBECU41iTCfr3Zc+R2xCg==', N'someone@somesite.com')
GO
INSERT [dbo].[User] ([Id], [Name], [Password], [Email]) VALUES (8, N'tt', N'9/t62b6F8YGmhFWBi9kwGQ==', N'tt@tt.com')
GO
SET IDENTITY_INSERT [dbo].[User] OFF
GO
/****** Object:  Table [dbo].[Role]    Script Date: 09/16/2010 22:11:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET IDENTITY_INSERT [dbo].[Role] ON
GO
INSERT [dbo].[Role] ([Id], [Name], [description]) VALUES (1, N'user', N'user role')
GO
INSERT [dbo].[Role] ([Id], [Name], [description]) VALUES (2, N'admin ', N'admin role')
GO
SET IDENTITY_INSERT [dbo].[Role] OFF
GO
/****** Object:  Table [dbo].[UserRole]    Script Date: 09/16/2010 22:11:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET IDENTITY_INSERT [dbo].[UserRole] ON
GO
INSERT [dbo].[UserRole] ([Id], [UserId], [RoleId]) VALUES (1, 4, 1)
GO
INSERT [dbo].[UserRole] ([Id], [UserId], [RoleId]) VALUES (2, 5, 1)
GO
INSERT [dbo].[UserRole] ([Id], [UserId], [RoleId]) VALUES (4, 7, 1)
GO
INSERT [dbo].[UserRole] ([Id], [UserId], [RoleId]) VALUES (5, 8, 1)
GO
SET IDENTITY_INSERT [dbo].[UserRole] OFF
GO
/****** Object:  Table [dbo].[Note]    Script Date: 09/16/2010 22:11:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET IDENTITY_INSERT [dbo].[Note] ON
GO
INSERT [dbo].[Note] ([id], [title], [content], [user_Id], [isPublic], [creation_date], [last_update], [tag]) VALUES (1, N'first note', N'<p>
	first note</p>
', 4, 0, CAST(0x00009DE300F19D6E AS DateTime), CAST(0x00009DE300F19D6E AS DateTime), NULL)
GO
INSERT [dbo].[Note] ([id], [title], [content], [user_Id], [isPublic], [creation_date], [last_update], [tag]) VALUES (2, N'note by gmail acc', N'<p>
	note by gmail account</p>
', 5, 1, CAST(0x00009DE300F34248 AS DateTime), CAST(0x00009DE300F34248 AS DateTime), NULL)
GO
INSERT [dbo].[Note] ([id], [title], [content], [user_Id], [isPublic], [creation_date], [last_update], [tag]) VALUES (3, N'second note', N'<p>
	hi all,</p>
<p>
	<strong>i&#39;d like</strong> to test <span style="background-color: rgb(0, 255, 0);">coloers<span style="color: rgb(0, 255, 0);"> </span></span><span style="color: rgb(0, 255, 0);">and fonts</span></p>
<p>
	<u><em>plus</em></u></p>
<p>
	<span style="font-size: 72px;">htm tags</span></p>
', 4, 1, CAST(0x00009DE700326A3E AS DateTime), CAST(0x00009DE700326A3E AS DateTime), NULL)
GO
INSERT [dbo].[Note] ([id], [title], [content], [user_Id], [isPublic], [creation_date], [last_update], [tag]) VALUES (5, N'test webshell', N'<p>
	<span style="font-size: 72px;">just t<span style="color: rgb(255, 255, 0);">es</span>t</span></p>
<p>
	<span style="font-size: 72px;">----------------</span></p>
', 4, 1, CAST(0x00009DF0002F7F65 AS DateTime), CAST(0x00009DF000341159 AS DateTime), NULL)
GO
SET IDENTITY_INSERT [dbo].[Note] OFF
GO
/****** Object:  Table [dbo].[KeyValue]    Script Date: 09/16/2010 22:11:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON

GO
